NTISthis.com

Evidence Guide: ICTWEB451 - Apply structured query language in relational databases

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTWEB451 - Apply structured query language in relational databases

What evidence can you provide to prove your understanding of each of the following citeria?

Identify database requirements

  1. Determine information required from database
  2. Identify tables holding this information
  3. Identify primary keys in these tables
  4. Identify relationships between these tables including foreign keys
Determine information required from database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify tables holding this information

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify primary keys in these tables

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify relationships between these tables including foreign keys

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Build and implement SQL in relational databases

  1. Identify and build SQL statements according to task requirements
  2. Create tables in a database using SQL statements
  3. Create primary and foreign keys required in database table
  4. Manipulate data in a database using SQL statements
  5. Query database using SQL statements
  6. Retrieve information from database using written SQL statements
Identify and build SQL statements according to task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create tables in a database using SQL statements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create primary and foreign keys required in database table

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manipulate data in a database using SQL statements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Query database using SQL statements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Retrieve information from database using written SQL statements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and verify SQL results

  1. Construct test data and test SQL statements according to organisational procedures
  2. Determine expected results of SQL statements
  3. Verify result of constructed SQL statements against expected results and document findings
  4. Confirm task requirements are met and obtain sign-off from required personnel
Construct test data and test SQL statements according to organisational procedures

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine expected results of SQL statements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Verify result of constructed SQL statements against expected results and document findings

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Confirm task requirements are met and obtain sign-off from required personnel

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

apply structured query language (SQL) to a relational database and gather required information according to task requirements.

In the course of the above, the candidate must:

generate queries for one or more tables and provide required data

add, modify, retrieve and delete records from database tables as required test and verify SQL statements.

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

organisational policies and procedures relating to SQL application including:

identifying SQL requirements from job specifications

testing and verifying SQL results

features and application of primary and foreign keys in database tables, aggregate functions and clause functions required in SQL application

principles of "combining and/or condition" in SQL statements and Boolean operators

IN and BETWEEN conditional operators

mathematical operators

table joins (relationships)

documentation techniques relevant to applying structured query language in relational databases

SQL statement testing methodologies.